IMPLEMENTING A MODERN TEMPORAL DATA MANAGEMENT SYSTEM

Temporal data management is a concept that has been around for many years. A temporal data management system (TDMS) manages data that is tracked over time. In this paper, the authors present an Oracle-based implementation of a TDMS that provides access to temporal data. The design and implementation presented in this paper are presented at a high level, with the significant features such as reference intervals and temporal relationships. The most notable TDMS benefits are a semi-portable solution and an implementation that maximizes on native database features. The paper finally presents an evaluation of the TDMS implementation with a feature comparison and benchmarking.Temporal data management

DATABASE DEVELOPMENT LIFE CYCLE

A software development life cycle model (SDLC) consists of a set of processes (planning, requirements, design, development, testing, installation and maintenance) defined to accomplish the task of developing a software application that is functionally correct and satisfies the user’s needs. These set of processes, when arranged in different orders, characterize different types of life cycles. When developing a database, the order of these tasks is very important to efficiently and correctly transform the user’s requirements into an operational database. These SDLCs are generally defined very broadly and are not specific for a particular type of application. In this paper the authors emphasize that there should be a SDLC that is specific to database applications. Database applications do not have the same characteristics as other software applications and thus a specific database development life cycle (DBDLC) is needed. A DBDLC should accommodate properties like scope restriction, progressive enhancement, incremental planning and pre-defined structure.Software Development, Database, DBMS, lifecycle model, traditional lifecycles

Landscape history, time lags and drivers of change : urban natural grassland remnants in Potchefstroom, South Africa

The history of the landscape directly affects biotic assemblages, resulting in time lags in species response to disturbances. In highly fragmented environments, this phenomenon often causes extinction debts. However, few studies have been carried out in urban settings. To determine if there are time lags in the response of temperate natural grasslands to urbanization. Does it differ for indigenous species and for species indicative of disturbance and between woody and open grasslands? Do these time lags change over time? What are the potential landscape factors driving these changes? What are the corresponding vegetation changes? In 1995 and 2012 vegetation sampling was carried out in 43 urban grassland sites. We calculated six urbanization and landscape measures in a 500 m buffer area surrounding each site for 1938, 1961, 1970, 1994, 1999, 2006, and 2010. We used generalized linear models and model selection to determine which time period best predicted the contemporary species richness patterns. Woody grasslands showed time lags of 20-40 years. Contemporary open grassland communities were, generally, associated with more contemporary landscapes. Altitude and road network density of natural areas were the most frequent predictors of species richness. The importance of the predictors changed between the different models. Species richness, specifically, indigenous herbaceous species, declined from 1995 to 2012. The history of urbanization affects contemporary urban vegetation assemblages. This indicates potential extinction debts, which have important consequences for biodiversity conservation planning and sustainable future scenarios.Peer reviewe

Tracking down carbon inputs underground from an arid zone Australian calcrete.

Freshwater ecosystems play a key role in shaping the global carbon cycle and maintaining the ecological balance that sustains biodiversity worldwide. Surficial water bodies are often interconnected with groundwater, forming a physical continuum, and their interaction has been reported as a crucial driver for organic matter (OM) inputs in groundwater systems. However, despite the growing concerns related to increasing anthropogenic pressure and effects of global change to groundwater environments, our understanding of the dynamics regulating subterranean carbon flows is still sparse. We traced carbon composition and transformations in an arid zone calcrete aquifer using a novel multidisciplinary approach that combined isotopic analyses of dissolved organic carbon (DOC) and inorganic carbon (DIC) (δ13CDOC, δ13CDIC, 14CDOC and 14CDIC) with fluorescence spectroscopy (Chromophoric Dissolved OM (CDOM) characterisation) and metabarcoding analyses (taxonomic and functional genomics on bacterial 16S rRNA). To compare dynamics linked to potential aquifer recharge processes, water samples were collected from two boreholes under contrasting rainfall: low rainfall ((LR), dry season) and high rainfall ((HR), wet season). Our isotopic results indicate limited changes and dominance of modern terrestrial carbon in the upper part (northeast) of the bore field, but correlation between HR and increased old and 13C-enriched DOC in the lower area (southwest). CDOM results show a shift from terrestrially to microbially derived compounds after rainfall in the same lower field bore, which was also sampled for microbial genetics. Functional genomic results showed increased genes coding for degradative pathways-dominated by those related to aromatic compound metabolisms-during HR. Our results indicate that rainfall leads to different responses in different parts of the bore field, with an increase in old carbon sources and microbial processing in the lower part of the field. We hypothesise that this may be due to increasing salinity, either due to mobilisation of Cl- from the soil, or infiltration from the downstream salt lake during HR. This study is the first to use a multi-technique assessment using stable and radioactive isotopes together with functional genomics to probe the principal organic biogeochemical pathways regulating an arid zone calcrete system. Further investigations involving extensive sampling from diverse groundwater ecosystems will allow better understanding of the microbiological pathways sustaining the ecological functioning of subterranean biota